Excel Macros: Excel Macros and VBA by Prateek Agnihotri

Author:Prateek Agnihotri [Agnihotri, Prateek]
Language: eng
Format: azw3, mobi, epub
Published: 2016-04-03T00:00:00+00:00

4.) See below for code in IDE.

Displaying table of 5

Working with worksheets

1.) As already explained earlier everything in VBA is an object for example worksheet, Range, Cell etc.

2.) Worksheets (“Sheet1”).cells (1,2).value refers to the B1 in Sheet1 of excel workbook.

Error Handling – Following are the ways for it

1.) On Error GoTo LineNumber (Goes to the specified line number and Code resumes from)

2.) On Error GoTo 0 (Disables enabled error handler in the current procedure and resets it to Nothing.)

3.) On Error GoTo -1 (Disables enabled exception in the current procedure and resets it to Nothing.)

4.) On Error resume Next (Control goes to the statement immediately after the errored statement)

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.